<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Applying a filter to a report instance: View filters</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
p.whs1 { text-align:center; }
img_whs2 { border:none; width:461px; height:171px; float:none; border-style:none; }
ul.whs3 { list-style:square; }
ol.whs4 { list-style:decimal; }
p.whs5 { margin-left:0px; }
ul.whs6 { list-style:disc; }
img_whs7 { border:none; width:13px; height:13px; float:none; border-style:none; }
p.whs8 { margin-left:40px; }
img_whs9 { border:none; width:17px; height:17px; float:none; border-style:none; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs5 {margin-left:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Analyzing report and document results\nRestricting report results: Filtering\nApplying a filter to a report instance: View filters");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Applying a filter to a report instance: View filters</h1>
<p>Once a report is displayed, you can narrow its results by applying a 
 View filter to the report. The View filter can include one or more filtering 
 conditions that restrict the data displayed in the original report. Unlike 
 the report filter, once the View filter is applied it does not retrieve 
 data from the data source. Instead, a View filter restricts data based 
 only on the report results already displayed on the screen.</p>
<p>You can create a view filter by qualifying on any attribute or metric 
 on your report. While attribute and metric qualifications both restrict 
 the data displayed on the report, they are both created and defined in 
 slightly different ways. </p>
<p>You can create a view filter in any report, as long as you have an OLAP 
 Services license. This includes reports connected to an Intelligent Cube, 
 reports returning information directly from a data warehouse, Freeform 
 SQL reports returning information from Excel spreadsheet, and so on. </p>
<p>For example, in the report below, the View filter is applied after the 
 original report was executed. The original report included data for all 
 seven regions. When the View filter condition is applied, the only data 
 displayed on the report is for regions that generated more than $2,000 
 in profit. Therefore, only three of the original seven regions are displayed 
 in the new report results. </p>
&nbsp; 
<p align="center" class="whs1"><img src="images/viewfilterexample.gif" x-maintain-ratio="TRUE" width="461px" height="171px" border="0" class="img_whs2"></p>
&nbsp; 
<p>To use View filters in Report Services documents, see 
<a HREF="Creating_view_filters_on_Grid_Graphs.htm">Creating 
 View filters on Grid/Graphs in documents</a>.</p>
<h2>Prerequisites</h2>
<ul type="square" class="whs3">
	
<li class=p><p>You must have MicroStrategy OLAP Services to use a View 
 filter. To evaluate OLAP Services, contact your MicroStrategy Account 
 Executive or email MicroStrategy directly at 
<a href="mailto:info@microstrategy.com">info@microstrategy.com</a>. 
 </p></li>
</ul>
<h2>To filter data displayed on a report using the View filter</h2>
<ol type="1" class="whs4">
	
<li class=p><p class="whs5">Click the name of a report 
 to execute it.</p></li>
	
<li class=p><p class="whs5">From the <span style="font-weight: bold;"><B>Tools</B></span> 
 menu, select <span style="font-weight: bold;"><B>View Filter</B></span>.</p></li>
</ol>
<ul><ul type="disc" class="whs6">
		
<li class=p><p>If DHTML is disabled, from the <span style="font-weight: bold;"><B>View</B></span> 
 menu, select <span style="font-weight: bold;"><B>View Filter</B></span> and click 
 the <span style="font-weight: bold;"><B>Go</B></span> icon <span style="font-weight: bold;"><B><img src="images/Go_icon.gif" x-maintain-ratio="TRUE" width="13px" height="13px" border="0" class="img_whs7"></B></span>.</p></li>
	</ul>
</ul>
<ol start=3>
<li style="list-style: decimal;" type=1 class=p><p>In the View 
 filter, click &nbsp;<span style="font-weight: bold;"><B>Add 
 Condition</B></span>.</p></li>
	
<li style="list-style: decimal;" type=1 class=p><p>From the <span style="font-weight: bold;"><B>Filter 
 On</B></span> drop-down list, select the object (attribute or metric) on which 
 you want to base your filter.</p></li>
</ol>
<p class="whs8"><span style="font-weight: bold;"><B>Note</B></span>: 
 If you want to create a custom filter expression, you can do so in Desktop. 
 Contact your Administrator for more information.</p>
<ol start="5" type="1" class="whs4">
	
<li class=p><p>Depending on the type of object you are filtering on, 
 a different set of choices appears, as described below: </p></li>
</ol>
<ol start=3><ul type="disc" class="whs6">
		
<li style="list-style: disc;" type=disc class=p><p>If you are filtering 
 based on an attribute, choose <span style="font-weight: bold;"><B>Qualify</B></span> 
 to set a specific value-based condition, or choose <span style="font-weight: bold;"><B>Select</B></span> 
 to choose attribute elements from a list. </p></li>
		<ul type="square" class="whs3">
			
<li class=p><p>If you choose <span style="font-weight: bold;"><B>Qualify</B></span>, 
 choose whether to filter on the attribute's description (<span style="font-weight: bold;"><B>DESC</B></span>) 
 or <span style="font-weight: bold;"><B>ID</B></span> form. Then, select a comparison 
 operator such as Greater than. Enter a value in the field on the right 
 to finish defining the filter condition.</p></li>
			<ul type="square" class="whs3">
				
<li class=p><p>To compare the attribute to another attribute, 
 click the <span style="font-weight: bold;"><B>Attribute</B></span> icon <img src="images/viewfilterattribute.gif" x-maintain-ratio="TRUE" width="17px" height="17px" border="0" class="img_whs9">. 
 Then select another attribute to compare it to.</p></li>
				
<li class=p><p>If you choose <span style="font-weight: bold;"><B>Qualify</B></span> 
 and are qualifying on a date-related attribute, you can either type the 
 day in or select it from a calendar (if DHTML is enabled). Click the calendar 
 icon next to the date field, then click on a date to select it. </p></li>
			</ul>
		</ul>
	</ul>
	<ol start="2" type="1" class="whs4">
		<ul type="square" class="whs3">
			
<li class=p><p>If you choose <span style="font-weight: bold;"><B>Select</B></span>, 
 choose <span style="font-weight: bold;"><B>In List</B></span> or <span style="font-weight: bold;"><B>Not 
 in List</B></span> to include or exclude items that appear in the <span style="font-weight: bold;"><B>Selected</B></span> 
 list. Then choose elements from the <span style="font-weight: bold;"><B>Available 
 </B></span>list and add them to the <span style="font-weight: bold;"><B>Selected</B></span> 
 list.</p></li>
			<ul type="square" class="whs3">
				
<li class=p><p>You can use the <span style="font-weight: bold;"><B>Search 
 for </B></span>field<span style="font-weight: bold;"> <B></B></span>to search for 
 a particular attribute element. See 
<a href="Search_syntax.htm">Using 
 correct and efficient search syntax</a>. </p></li>
			</ul>
		</ul>
		
<li style="list-style: disc;" type=disc class=p><p>If you are filtering 
 based on a metric, choose a comparison operator such as Greater than, 
 and type a value.</p></li>
		<ul type="square" class="whs3">
			
<li class=p><p>To compare the metric to another metric, click 
 the <span style="font-weight: bold;"><B>Select</B></span> <span style="font-weight: bold;"><B>Metric</B></span> 
 icon <img src="images/viewfilterattribute.gif" x-maintain-ratio="TRUE" width="17px" height="17px" border="0" class="img_whs9">. Then select another metric to compare it to.</p></li>
		</ul>
	</ol>
</ol>
<ol start=6>
<li class=p><p>Click the <span style="font-weight: bold;"><B>Apply</B></span> 
 icon <img src="images/apply.gif" x-maintain-ratio="TRUE" width="17px" height="17px" border="0" class="img_whs9"> to apply the new filter to the report.</p></li>
</ol>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
